SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (last_name = 'CHUBBUCK') AND (first_name = 'H.%20Eugene') ORDER BY type ASC, date, patent |
No patents found where: Last Name is 'CHUBBUCK'; First Name is 'H.%20Eugene';
Total of 0.00 seconds